[dbo].[ContentUserDefinedFieldValue]

Property	Value
Created	10:31:18 AM Tuesday, March 02, 2010
Last Modified	11:40:01 AM Monday, February 20, 2012

Property

Value

Created

10:31:18 AM Tuesday, March 02, 2010

Last Modified

11:40:01 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_ContentUserDefinedFieldValue: ContentDocumentVersionKey\UserDefinedFieldKey$	ContentDocumentVersionKey	uniqueidentifier	16
$Cluster Primary Key PK_ContentUserDefinedFieldValue: ContentDocumentVersionKey\UserDefinedFieldKey$	UserDefinedFieldKey	uniqueidentifier	16
	Value	nvarchar(2000)	4000
	ValueText	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_ContentUserDefinedFieldValue: ContentDocumentVersionKey\UserDefinedFieldKey$

ContentDocumentVersionKey

uniqueidentifier

$Cluster Primary Key PK_ContentUserDefinedFieldValue: ContentDocumentVersionKey\UserDefinedFieldKey$

UserDefinedFieldKey

uniqueidentifier

Value

nvarchar(2000)

4000

ValueText

ntext

max

	Name	Columns	Unique
$Cluster Primary Key PK_ContentUserDefinedFieldValue: ContentDocumentVersionKey\UserDefinedFieldKey$	PK_ContentUserDefinedFieldValue	ContentDocumentVersionKey, UserDefinedFieldKey

Name

Columns

Unique

$Cluster Primary Key PK_ContentUserDefinedFieldValue: ContentDocumentVersionKey\UserDefinedFieldKey$

PK_ContentUserDefinedFieldValue

ContentDocumentVersionKey, UserDefinedFieldKey

Name	Columns
FK_ContentUserDefinedFieldValue_UserDefinedFieldRef	UserDefinedFieldKey->[dbo].[UserDefinedFieldRef].[UserDefinedFieldKey]

Name

Columns

FK_ContentUserDefinedFieldValue_UserDefinedFieldRef

UserDefinedFieldKey->[dbo].[UserDefinedFieldRef].[UserDefinedFieldKey]

SQL Script

CREATE TABLE [dbo].[ContentUserDefinedFieldValue]
(
[ContentDocumentVersionKey] [uniqueidentifier] NOT NULL,
[UserDefinedFieldKey] [uniqueidentifier] NOT NULL,
[Value] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ValueText] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[ContentUserDefinedFieldValue] ADD CONSTRAINT [PK_ContentUserDefinedFieldValue] PRIMARY KEY CLUSTERED ([ContentDocumentVersionKey], [UserDefinedFieldKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ContentUserDefinedFieldValue] ADD CONSTRAINT [FK_ContentUserDefinedFieldValue_UserDefinedFieldRef] FOREIGN KEY ([UserDefinedFieldKey]) REFERENCES [dbo].[UserDefinedFieldRef] ([UserDefinedFieldKey])
GO